SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 278041 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 278041 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5557,952979,521183,613297,165697,457695,357714,402474,126840,223184,469352,552253,200578,323631,810473,11893,857927,735647,286892,485321,992658,1002118,15800,204667,969138,743884,517065,95194,525440,323481,588236,528752,467559,1013071,271026,459478,97398,627020,589762,248573,39778,482691,227097,974950,19028,34544,421564,530918,946474,604279,945874,500740,831573,661904,683687,223053,777075,81119,444096,371909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 278041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 278041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]