SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531411 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531411 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23530,593450,346993,100618,881901,764180,986598,568958,717412,1004180,340784,315896,992985,115791,218167,974026,637796,433630,779201,602434,630521,233323,593043,989703,460138,650386,511833,396820,26966,1003810,320910,593297,1015489,741082,868163,93597,703161,416455,910208,442531,818426,566116,689278,49455,892502,107043,388022,528891,460416,293795,769161,240267,36495,152075,845792,757964,190957,163972,58003,1025802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]