SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422180 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422180 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016075,1009393,343983,983210,168511,217206,307066,496199,1047052,868800,634038,266779,224040,237957,718303,911947,726187,271801,326964,941496,847544,77836,779728,865963,221523,121354,743589,308259,643152,982579,574329,594134,955754,129883,739118,778923,595854,196998,167533,517106,214209,1019395,797268,790064,554025,946267,900797,714451,409418,966361,979213,153871,547031,142170,241914,370184,807849,598328,375933,876877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]