SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683881 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683881 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431144,640422,898874,234836,202221,463498,118738,422837,520030,254739,154309,1006106,427863,51706,101799,912710,239827,138484,537077,1022737,657166,356719,8973,865926,549496,1001150,151003,401446,188559,320081,670248,611775,335912,719898,170265,294446,462313,1036004,326429,1038070,100496,322355,425422,787464,177623,734538,665948,533251,68494,559238,687987,881814,573751,755840,238759,589762,922905,857212,818295,151707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]