SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019102 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019102 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387218,951303,294202,344854,496788,293583,451243,16626,1006151,928108,1002656,463565,205497,257126,1007321,364688,920717,112933,863299,982108,208721,737050,712560,255736,934468,926328,187630,227676,427342,1016106,803346,15083,253860,196962,718109,396390,144427,792415,933753,1019063,929171,141333,732118,1039106,290180,683761,209209,841810,933677,948512,396832,634346,361541,605589,968424,232839,404808,194369,388969,244127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]