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` = 1027802 LIMIT 1 [ RunTime:0.002460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027802 [ RunTime:0.002733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94570,664335,28020,643904,724300,206418,1043180,937969,99649,444136,475191,90192,546972,411343,674724,678454,8578,1037427,944511,46572,770691,207902,124761,332277,958464,798938,548635,415636,738003,340794,355729,901567,555295,289963,218160,910709,163674,137867,154295,72927,474111,917930,1010466,1007193,620256,394325,742880,94582,254426,842743,297712,645525,355644,1005206,739811,457611,66978,150592,994575,911597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]