SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672010 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672010 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151543,325055,744459,266681,1038530,152245,197392,365943,172465,756434,573103,815113,516859,276161,740970,503680,63183,654825,6797,745938,141611,485991,922035,22430,129436,215499,913120,175488,611578,1018664,545947,841959,301962,404130,493355,366134,549640,632546,992953,50558,505867,980413,44398,151670,627760,1001805,638948,67944,523393,961357,568414,632637,423327,184997,22202,367102,803715,920596,965847,32917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]