SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021463 LIMIT 1 [ RunTime:0.000805s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021463 [ RunTime:0.004361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68575,713689,520898,390940,330952,440442,298112,789909,622423,896952,521493,210696,522368,73228,685285,522022,6982,284649,923440,385329,110913,217412,945377,972410,340879,366158,192623,811019,817404,394511,413868,984869,841675,369392,87063,180760,578672,794318,60553,260476,823201,615901,798587,528814,16418,359066,513417,226980,940501,921895,185011,231237,839169,999048,655584,546492,704045,922010,193103,449250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]