SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417668 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417668 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222909,225168,953557,11769,939317,24847,185293,966546,416956,138390,56130,77750,580617,110601,419405,539892,406254,385274,454266,735447,578331,981188,480547,867348,470918,642281,471147,518307,558068,19216,839288,703735,931959,67694,543853,801997,398415,890860,580757,81748,744259,130408,242477,512532,332125,633867,262300,312879,204159,596620,871760,184691,586953,723274,482825,193037,334614,182246,760018,612549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]