SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542832 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542832 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588693,421915,115583,753045,408080,407037,1029634,72510,898989,753189,418062,799264,223798,478901,673135,558493,23144,997505,605292,138413,521073,827607,409542,563178,369109,607366,453172,599260,644871,732039,543959,97240,121256,791576,18409,1010790,654457,105130,142445,272532,464358,518296,277197,3400,874158,230643,454509,576466,951174,784695,353663,484639,893015,83721,927263,636990,543574,256767,903321,419240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]