SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029011 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029011 [ RunTime:0.003231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469505,31380,75055,895495,713559,137542,394458,716750,238332,25926,86883,72982,571184,195598,1008687,228612,153616,318497,655094,1686,304468,153883,794248,178139,344849,472015,853869,482137,219647,137465,238335,984538,1034214,820660,948663,25507,347322,288980,1044954,966772,934465,494948,740841,264380,864125,673665,305289,721492,832026,711069,715066,837999,328740,766512,355433,1046819,929029,868832,460342,86513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]