SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439331 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439331 [ RunTime:0.002776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554168,609411,892865,978497,679550,127130,245358,33224,156509,340346,83140,122965,642965,553864,703887,379216,449672,261084,510903,45565,544872,1023223,867833,1037618,336458,523374,341346,231139,781946,861379,96441,1012734,216675,193434,425387,174962,610671,156664,134990,169841,69223,486950,874725,999716,763727,1002071,932046,568567,995026,126249,207286,648169,721546,148495,64422,603750,406191,202587,236733,332670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000783s ]