SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285413 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285413 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958717,654995,297543,661157,337278,533421,31842,479228,48621,798393,649578,986293,598770,922150,928109,927840,69117,440857,354090,828689,334832,748245,152992,51565,298757,398700,317514,133192,242885,501475,1045290,694296,27281,155731,861655,648929,163210,676333,678726,976947,909915,2133,490130,765305,877171,7142,681761,525781,361731,628676,960779,117944,542158,634907,935132,413050,714781,799251,451746,538967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001015s ]