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` = 1010229 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010229 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477141,713421,871043,102910,281538,539680,401383,624184,198740,8390,1045905,838847,207528,723973,34128,512955,732729,390104,9180,300289,983221,1003802,780132,979886,679718,226163,183838,107384,28203,821452,243570,309250,802855,745289,862456,882878,864037,970283,812191,944156,1015303,68731,570279,398796,23635,182526,615151,825486,451580,935976,845032,1039577,792458,1027336,988957,12234,944734,934137,221321,150516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010229 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010229 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000923s ]