SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104506 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104506 [ RunTime:0.003584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945315,555430,292264,335702,605663,1034231,327372,150287,143620,982205,1005277,155781,944386,436472,822647,973915,754315,933744,491607,5936,436030,192092,402833,55655,986624,504306,508306,57651,540871,811466,756190,469390,1041455,580829,423217,371261,714540,158845,939770,594109,432160,738425,591545,598231,357763,707245,274002,658752,281939,480718,473259,704908,113169,900400,11690,797106,130702,948409,649715,274524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001785s ]