SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565018 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565018 [ RunTime:0.003094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753920,942590,838528,423967,751861,580567,614149,1007140,904460,1019325,896583,494185,553914,914552,319020,146127,972225,1031754,148918,17919,302270,1021356,222453,447996,273248,260139,675979,776622,469635,426174,1030242,810114,968895,532753,173865,862938,996196,364928,428696,943124,699900,184852,1026415,1010446,134199,736566,1011403,820957,972615,283267,388668,377235,213956,91748,252315,440508,879941,668663,175820,646672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]