SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004368 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004368 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765897,697318,96084,252224,65754,113229,736807,141613,133584,343797,864414,500480,968047,200472,444261,289667,39990,97419,718846,682542,127863,1020046,920419,655866,290801,1010738,651276,392253,159182,228442,816861,551146,716764,343944,773727,724608,206211,581781,842818,289910,785449,497909,632502,702351,960017,1032704,849064,87852,695795,280280,925239,541248,114581,1038240,627698,42937,313318,82499,701201,239635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]