SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472455 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472455 [ RunTime:0.002528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939760,1016164,631287,613223,415158,595676,913632,252731,759799,369005,966640,1022176,300008,609035,540458,419453,582738,35821,320382,482713,361716,108938,20427,511338,10428,690141,935133,570069,94335,706432,280844,402046,402890,373643,383780,717035,548068,362055,788577,927527,249466,746091,957204,773236,418533,943495,22112,24627,864930,752530,195131,97372,990767,1042229,882177,808218,404168,743697,843510,258152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]