SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027034 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027034 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251531,1020821,317379,985586,540871,732625,205536,549380,703545,110533,70118,152825,94509,675428,757859,9235,775236,530428,473670,925487,27031,312831,1000264,661734,517389,13621,742804,14104,520495,581509,650665,899139,130110,130043,22298,405526,1030239,1046151,385275,212555,813665,465355,854881,373763,880760,118129,716768,474889,960845,954649,104288,29379,343788,736757,475399,260616,311072,861253,543490,269622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001070s ]