SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450443 LIMIT 1 [ RunTime:0.001724s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450443 [ RunTime:0.002703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534848,157219,91994,336847,807363,260395,724909,643420,597606,853420,661911,705176,233597,59651,500551,702244,698526,808129,924896,1048002,128990,959141,357612,575619,558595,450274,910434,925603,610891,594935,1048060,710184,839552,211176,996100,693815,378941,589680,950723,613936,299494,64895,719122,865893,680917,39323,758039,811806,89880,446473,492067,390221,691797,659829,683444,580138,877833,397651,138520,221823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]