SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317810 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317810 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63216,175722,316356,349054,745925,319920,822364,142273,752380,173185,503529,425763,354402,139900,28779,248608,1030959,869187,899639,307693,462805,1048677,641682,300050,43178,894699,42661,203248,77050,234732,1009602,27018,633005,1029965,431844,52306,500687,199028,1007426,110083,865889,837564,88559,39782,450167,334926,535314,581456,351963,839316,215380,246045,862331,342896,1006591,679032,19833,326742,528346,662603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]