SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042766 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042766 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455511,981396,252365,377730,558032,838593,14410,510965,414751,688396,854714,712271,441686,335745,485268,612943,178566,199678,884956,708115,544684,912198,884966,1004468,40763,428408,175355,840392,827971,955828,374194,434817,474156,671323,482095,899262,215004,71237,591405,973880,864596,329429,8679,681001,1044779,685253,646243,993918,1034799,270147,1000970,972642,872023,998449,362524,545391,150086,1024393,44732,673458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001616s ]