SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460081 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460081 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44014,727191,939713,805119,676610,146964,204979,667711,237533,325455,407935,1032898,337621,909870,687216,352631,779786,390755,445769,431137,268454,602248,166628,383350,1013540,65026,254666,531811,776544,347751,21037,427005,158406,415242,303390,625488,954781,644913,625860,903390,106347,169013,360193,443407,544856,24972,90364,738395,707460,662216,224985,795353,762782,394880,391875,316267,434781,255706,919122,633958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]