SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404723 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404723 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5508,922049,241709,607460,780311,303520,343108,1019914,456326,381304,26100,292638,415598,611686,320561,330563,235269,186594,820314,449442,91960,95797,72916,277599,627023,834432,401672,346522,520281,655613,941559,418246,1042940,546795,179264,947429,1024330,712529,212410,1026210,360484,199517,414356,464478,1011659,254304,735452,498872,963800,670338,71286,904190,834984,817745,366192,734416,733264,314881,1043706,617362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]