SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045856 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045856 [ RunTime:0.002437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245266,332841,563872,276410,485594,227388,235172,798410,476382,84248,288893,835568,863931,61877,525203,993492,713053,76081,268376,69110,130666,743002,57938,699513,623737,865880,53537,586477,100369,1043527,133077,237501,843010,923349,808048,214302,171381,81240,471788,1007333,645739,856103,319731,444981,1013456,129338,266145,760812,607863,49560,73327,330921,386487,201194,360862,512153,814722,775575,443701,570568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]