SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467082 LIMIT 1 [ RunTime:0.000708s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467082 [ RunTime:0.004864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736258,362178,1038847,686425,556456,834531,403251,754785,699590,836778,293566,519851,707501,254121,605293,472780,943567,448945,24923,157769,463141,384084,246109,23332,507403,618411,626367,871098,180087,422212,701197,171500,954865,375003,1021940,739792,400050,201120,774989,686977,656161,620898,716882,667085,546041,172319,678788,798623,1024474,19862,692693,63890,48057,525177,354024,347223,782161,935678,739818,902336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]