SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542593 LIMIT 1 [ RunTime:0.001832s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542593 [ RunTime:0.004027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886934,680750,876927,442338,90790,970042,258315,915054,809361,1029574,834426,847211,899892,305651,811748,721498,275901,967735,100235,747928,598309,9532,525632,973618,342047,421063,349436,197859,1007658,42592,629409,520865,44904,615196,605875,192880,138380,674232,442287,368816,438021,996800,322739,9873,980801,882875,500480,172027,122032,807287,658262,700100,138333,371012,384688,782498,159960,525996,860161,633731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000947s ]