SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337283 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337283 [ RunTime:0.002911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420286,320164,525299,496836,357340,118934,977480,391620,1032268,90845,386871,432336,968478,75847,923553,503735,810384,965240,881616,129747,944196,908707,440895,451912,453175,340908,441116,575828,172388,521548,736532,1031680,1039513,185314,242510,14509,865447,638234,462874,452814,590397,908798,201375,1030752,798031,384944,203001,130291,601993,914357,116939,257113,529885,720707,815907,190874,536891,852012,650297,527883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001230s ]