SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479095 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479095 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443322,450154,542236,1039950,121174,448690,787123,467471,427559,539079,748795,117978,147370,862507,921435,100813,420827,793239,742086,600097,838308,94466,1022202,85690,232599,102508,119256,863658,285101,832989,728923,254377,285888,1587,406521,229525,821776,870085,409298,124044,1046784,507233,124032,710207,909487,511615,504663,436423,278937,499072,3565,206998,832727,328653,303257,1029109,760257,424340,490493,546720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]