SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103521 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103521 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318094,1034441,137622,495348,549451,377865,483621,888955,826841,752430,971274,2011,701813,1012310,102721,263289,763119,274101,46966,495045,350232,385760,904125,618696,441580,474401,657972,480430,636463,579199,18742,328907,1009535,634467,965687,301804,1003107,924104,188898,598230,443666,801064,165365,591254,753250,342389,638156,487838,897209,219081,135682,454229,902611,863216,896117,538073,247526,287000,640851,1016130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]