SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804310 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804310 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129659,780184,425289,840664,105078,168578,822731,307055,423983,869911,1031130,766587,188764,663335,317267,542014,906517,168247,710090,305379,445610,965253,769500,356579,746756,981148,74980,571778,341616,952358,786088,391324,312745,474411,914718,833456,1009449,878193,953698,157364,542097,848720,716276,709896,657417,869485,20539,325279,89471,890851,375293,270895,693650,896526,578704,924714,554165,658165,863814,942819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]