SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488310 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488310 [ RunTime:0.001416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886910,637178,425952,850300,922195,749442,826122,855880,452878,682684,246697,505648,1011915,925731,829038,167727,875115,807533,341273,262664,517005,866202,859577,147447,11619,819695,128844,110936,924732,715699,947688,57111,940877,611137,640167,384697,731461,587257,285086,729920,756365,615330,226729,880348,547543,491730,61459,573702,554599,393551,846834,846740,718853,112444,342919,223298,569396,863377,319024,612083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]