SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453260 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453260 [ RunTime:0.002116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715563,484216,214783,904745,1023135,930545,891829,305175,422034,371461,448912,605419,707593,902189,84556,357165,631412,112536,729332,279291,585377,865691,406581,362264,196834,336867,82243,602411,511894,55239,1018472,494482,815375,780023,481888,1020263,187855,887798,833902,194051,31178,97860,132078,482287,70623,58245,930455,1044702,373931,290501,171693,907730,1040233,432074,182676,228034,314301,651625,931590,764479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]