SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442528 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442528 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331044,392093,157644,49472,976529,975638,7586,921091,687548,279748,455933,79488,942996,513469,102047,609235,857032,183699,562074,535699,180949,468409,530122,733696,398878,436108,101915,922725,77754,729284,83058,738776,84156,717531,127149,62111,564992,37489,646431,86665,158520,35704,246466,576407,279482,907335,303845,136121,309033,132627,581262,76450,2430,564085,912258,134778,471570,505648,545103,404797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]