SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407193 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407193 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873215,54163,119927,906423,958908,342064,498911,676462,395810,599497,967023,832159,201543,15323,146837,913393,561056,816866,423507,948039,252728,735780,629973,793298,1030626,718956,1000278,366121,83613,1035562,653042,165939,1030794,809852,597000,616314,991010,388960,877305,41428,509289,641407,1037394,247504,1009882,202735,405830,657900,663729,878912,1007816,707253,581169,472199,756726,415095,35059,437368,343178,396409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]