SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564806 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564806 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408203,641533,1030079,358152,576435,224921,912083,165248,879720,1037772,968357,652709,409758,106816,27984,419638,881170,266843,461573,596199,553188,970298,32796,757490,168915,909121,271736,961596,806792,980295,795600,320680,283473,871444,706249,67606,490467,1004093,688041,73987,171291,307873,743738,160967,616454,147933,670177,394117,212955,728146,646984,701328,232124,232367,171672,893618,550370,151430,15917,551336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]