SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037810 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037810 [ RunTime:0.003762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121510,933453,947063,610559,200350,913012,883147,6590,764413,998159,135021,704607,372917,350688,663530,897471,74405,63114,1043361,471788,694995,580898,328702,33564,18416,1003304,1002665,367722,22809,822761,712928,329457,318922,189486,257859,673309,821337,133117,34740,907700,536298,265633,180250,459566,974768,209082,77493,358439,281923,69919,695101,458504,749122,445692,791486,519721,485132,907669,818586,384043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]