SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150528 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150528 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912538,517723,804287,57750,322135,14368,531092,68861,974439,860463,599350,249392,861613,53174,619259,374272,26158,729573,313970,330046,270193,592141,829864,674370,764905,17647,715369,425829,899522,532910,964174,428965,547462,192053,417584,724478,824016,983463,791326,1042836,100968,870597,640478,319747,605103,875194,35568,940942,915608,341980,519236,556949,13613,601397,828387,835408,388174,396294,318894,525712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]