SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465458 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465458 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498814,132570,131699,353317,704918,625338,342312,838369,822888,787896,223151,910918,233268,180458,506317,82096,115911,615822,651163,1043675,522787,847282,98262,487176,579260,462354,213873,788068,649239,526832,579624,102865,577173,321265,820253,56574,870355,925331,950448,7046,346743,150343,468446,516514,881284,410966,405943,28101,251723,229067,849744,399979,265449,729099,949062,543541,356804,466366,512623,650144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]