SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407900 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407900 [ RunTime:0.002322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409636,891357,440423,911466,394963,837564,150371,607200,137802,331467,861155,396031,518091,734171,731412,316847,471867,809019,532682,382625,603519,169068,752060,210463,243245,428970,257239,384713,102279,994650,682472,528241,664329,384211,722815,859957,729394,914933,205591,307771,138334,713968,48134,921530,160651,799064,577378,932163,327554,539067,592701,52341,1029222,116577,384559,487774,145058,782732,501556,1036039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]