SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204002 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204002 [ RunTime:0.002332s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953446,926880,325914,506631,20995,600663,549963,345089,417650,480245,612832,539196,203599,532670,788268,463712,441680,522912,20684,391428,136102,830713,12918,706809,990514,786756,788880,453923,763423,87250,983821,612001,245296,132097,745492,751349,368289,840152,949424,550269,538330,182794,265752,216611,88727,272074,655136,273748,16698,836426,267284,871219,585898,758106,386576,449424,240685,276868,812039,181653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]