SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543259 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543259 [ RunTime:0.005286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122358,380415,322644,87237,942406,821687,334563,24528,879838,416454,5639,502072,932164,938490,559510,1037990,279468,147186,935612,82844,892082,798943,858512,633576,24958,606339,147244,3032,972849,294021,239567,1030878,82186,749196,134330,954914,193140,682276,352436,1019278,882891,13399,552854,698904,837850,436538,446165,894540,831729,245896,201278,715367,257434,602599,924618,685027,928734,198962,679315,161580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]