SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504777 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504777 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853824,227136,564133,44242,791631,161755,26585,110348,427133,591072,921376,797807,384875,870038,410022,659147,439777,393985,243959,378428,711826,393535,465071,696748,155727,281650,184140,7991,797714,388297,192031,295256,151334,203042,500533,737314,36675,1025063,541287,877360,819236,19277,590531,71393,108856,266619,430470,275152,522606,384010,308490,281933,219403,571423,445895,211314,524085,569736,893146,308752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504777 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504777 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]