SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571952 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571952 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015306,195430,117439,786924,985864,3844,11262,258316,157738,300219,503795,803601,300310,349257,823601,722442,760150,336188,973557,335453,780900,695444,822023,734190,714434,289600,346613,910682,904898,556130,167473,11449,104314,354080,399802,169164,847179,324663,462424,531769,465725,629941,160598,859999,129147,893179,477095,623441,758879,679235,449111,449633,529387,90265,14233,718058,112524,991634,7220,985122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]