SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529670 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529670 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287229,690625,3720,401855,622518,133485,845600,1048872,182606,517869,479914,16189,357726,692454,900918,410543,223257,482903,220367,504790,577590,900718,229980,984103,1010485,816826,950982,993443,64433,144326,89039,919758,80110,1001531,364842,937360,393983,1039030,44669,902544,581095,779739,235423,799970,170586,582801,724532,594705,682650,403987,430473,284621,963631,828721,308138,575134,277713,979984,912853,706995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001045s ]