SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211233 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211233 [ RunTime:0.002303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019004,445238,1048158,241405,430603,416541,962623,539710,852974,1042009,852637,744648,645481,744604,63832,766763,312783,721759,109930,918946,737607,553590,347143,549797,228775,383440,993923,536934,924749,170559,468912,585375,953994,982174,355026,936714,13650,699566,585717,637359,267798,323111,752983,353915,524891,752738,1039636,49885,292837,711618,890987,426672,515680,851062,897263,375488,321842,115016,856289,606275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211233 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211233 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]