SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414641 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414641 [ RunTime:0.003590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93286,4063,460764,612126,918184,901397,266248,269778,284463,849257,440212,882816,417560,881228,574950,671783,102044,677977,608139,275744,178038,501985,597296,523246,27873,604903,797195,418320,752296,3020,48534,143138,470003,199940,372703,703077,656356,451759,312692,952434,1031032,816188,631372,31536,450134,997543,1026134,437533,831033,882384,1015453,589881,1038920,108052,301674,524814,601765,317887,131910,267938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003320s ]