SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204481 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204481 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693585,1038825,541970,910057,28580,1003906,98791,497369,387188,303082,431415,981909,700253,715860,20645,977494,630861,411021,991645,290179,813645,511249,176451,47935,556352,134956,281433,393158,663,299418,592532,747795,154796,266667,127197,924198,147239,103702,295481,995790,753341,710739,313561,68070,692023,371197,777827,299215,1038101,992736,554541,814103,982453,366695,486159,551871,918914,710823,793668,361428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]