SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53683 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53683 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584019,218266,541913,559379,995177,659532,867994,563740,48460,108812,944917,939473,1005232,490162,469424,94090,938906,782831,488338,311013,1024247,554893,231235,673542,707591,219016,76275,504774,464175,780364,151271,964734,62014,276091,41427,275396,740532,824654,211442,564759,735403,852258,350596,578197,362795,889063,691733,520959,741747,819061,518800,109700,299989,927903,1001389,463543,190362,712233,608664,858608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]