SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333541 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333541 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496573,857590,24870,345462,621715,942334,762619,682301,910969,130257,550129,673544,888028,779292,195927,1014223,220915,742222,1000260,743706,715869,371321,446288,673084,300306,1005495,234938,419076,88440,208112,793299,301686,565024,538287,48628,443704,356220,465498,587926,903392,766193,777821,733355,432192,275249,42926,67155,873596,112012,284436,533730,883791,996279,920718,132341,727431,610378,144749,621926,282289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]