SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349847 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349847 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252011,811995,532013,593647,792385,433060,345101,679327,302224,988903,596706,648677,906112,759078,223435,8213,1048245,298324,837689,222118,695680,337034,733000,834114,203348,209178,204472,101864,618779,617302,930137,323034,167314,148841,207303,755666,324900,672168,826315,269407,823111,666761,610485,879563,455498,157163,994156,589559,378500,510777,929938,76354,196042,328856,481305,138557,910128,764620,276354,1007023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]