SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982913 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982913 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267997,181365,495911,550902,494326,243604,1001449,766812,793942,724486,959004,82315,643162,754341,381187,460707,154912,847416,476555,1044615,267951,227653,761717,211067,671955,429909,155082,427531,659111,604707,407542,966650,879893,98761,511816,640357,966743,280148,165189,1000016,643045,887332,64217,111864,100425,241480,645642,546704,9994,687788,161854,344114,842763,949359,213206,677469,886592,942953,907210,539480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]