SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491930 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491930 [ RunTime:0.004461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32000,1044066,135005,971433,827608,63188,324730,550487,125393,590783,18785,342365,199482,135010,947954,494316,423647,615074,724164,269060,884947,851264,212674,1046662,829092,810965,559612,1009258,420268,631071,974504,85097,635580,219964,662366,754571,447360,509851,18532,551387,161303,389595,650993,374942,831385,123764,427514,387534,368131,297688,907277,79246,205480,341484,727354,547731,53758,634814,873229,518685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]