SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034300 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034300 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672860,922001,384056,624200,691256,485592,55842,125350,387695,754298,648413,447141,539332,807885,89756,848147,931265,179945,287128,501960,450111,485495,156255,726379,261175,696959,47482,415265,179042,612713,376774,1009607,168754,208845,128673,433809,654261,553255,603545,746527,564146,619351,83790,325637,706298,363629,628600,187293,690370,655789,1046104,661925,202902,515576,561233,450938,459011,594061,523343,848157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]