SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200435 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200435 [ RunTime:0.003477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180179,14870,750508,181649,20038,303759,1043127,832316,95675,220202,929317,60330,741950,449809,974023,780016,411378,978326,710380,406581,783736,534852,492052,370432,71540,901763,632443,572777,544662,754584,237232,732698,832837,188707,193298,251290,645638,651256,696525,396783,458498,609932,775986,403093,226017,205446,600656,104437,726180,881959,524650,367245,666636,346849,416752,716015,585014,437487,125666,828999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]