SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401117 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401117 [ RunTime:0.002874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313002,775821,689271,228210,970265,811833,901540,624555,666498,1002058,715907,52348,632694,773560,103675,367912,5494,74630,499593,505282,693082,1026411,987069,466016,33355,16056,712331,521316,623935,514634,400094,292691,222513,725832,5010,674588,102425,61328,134185,342134,972429,303380,189173,365248,739834,925466,337777,54601,16852,616144,810179,71979,683546,495023,924606,290824,970255,348048,195897,718009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]