SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443376 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443376 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499839,586757,299600,625230,216331,1006981,288751,1032020,796982,803367,581075,846803,207251,490347,429661,171148,531278,288709,1039862,200176,964399,141742,1034211,640222,669914,352464,860786,774087,60936,699961,51001,625023,373553,261088,863470,499894,869999,704672,642152,1041713,520109,577707,8094,862391,208830,471808,724325,267614,647874,795148,567200,328061,885612,248031,702995,191626,255062,984642,197018,62838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]