SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255211 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255211 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040940,968738,193918,528543,258559,975219,912736,591537,477203,21787,135368,258135,370373,905624,250417,51708,961752,425911,945222,419158,843365,963164,475182,199504,595096,219105,942125,376755,932075,921,49577,574165,526857,1004965,686183,615665,140029,88704,325941,163959,794432,553857,471057,432492,626264,456912,558683,915240,1029663,336237,157208,18157,762233,755998,166732,747443,469189,980131,807830,300563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]