SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476209 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476209 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (769191,412210,1045094,517171,976144,868791,150758,859682,200622,178446,148278,522834,497165,510123,394961,655382,518036,945343,870798,538869,689076,886386,27809,434280,140475,527511,17920,143399,89730,130053,669824,821358,416821,871558,214442,508652,951856,806418,134624,1021689,621742,624387,161493,299432,562416,37231,144247,292274,402194,857487,331608,533221,380961,612930,428048,892535,55931,787339,474195,952311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]