SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264043 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264043 [ RunTime:0.003570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789760,852912,369705,884754,714625,310635,348007,217782,147411,1045645,513780,147082,35275,197192,824144,198013,751257,195385,564351,765466,79771,934596,485928,430070,94385,779809,588168,850954,433062,419939,699195,756157,912300,440887,171999,770601,428879,559782,226426,115241,1452,341571,958757,556261,405868,43547,267010,669442,381924,642104,147014,184482,165248,29830,806380,684105,414519,530539,856961,905530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000980s ]