SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040159 LIMIT 1 [ RunTime:0.001113s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040159 [ RunTime:0.003609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594021,75030,392922,983123,1029345,817471,868228,690363,834167,396881,658354,735256,519329,233851,640694,190422,856934,987673,749651,768376,183086,767451,144596,822323,709550,220611,822913,856403,807449,904939,59203,866864,601446,273412,258209,444384,605227,773548,532381,104055,966846,442377,1012048,471726,896833,181519,353054,938040,232719,483190,614391,156856,563668,695369,71064,961270,779667,180124,425414,175705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001720s ]