SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002634s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44780 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44780 [ RunTime:0.004423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797863,495126,739939,35734,326314,864781,355717,282022,938935,286187,463675,921029,144263,461752,1004748,966155,10591,696591,10435,134883,711104,27670,586807,587600,859724,115773,988993,571635,26910,582027,484031,562058,850549,213597,130361,352188,451362,790999,1036055,3244,807817,263327,890576,942955,645923,751757,599011,451261,188032,655241,467151,375745,289740,836835,637922,534213,123899,981185,299298,508227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]