SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505288 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505288 [ RunTime:0.001480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576242,100679,742079,956522,135942,707175,490940,287156,22588,467682,171656,894538,282572,949657,225899,581617,5806,578900,846640,37601,815595,1033305,1003695,742237,1010171,472749,1031785,588949,512520,341861,773680,823051,701529,285450,352303,995372,940421,680623,1046458,986191,718380,410776,591276,564395,812497,715101,92151,59922,258068,845019,811325,682407,188479,301600,644597,909417,305419,300899,984144,149303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002014s ]