SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31499 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31499 [ RunTime:0.002569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197215,618807,717258,665679,509729,1038048,537316,459361,1010992,1041473,206715,97789,888709,435339,407116,132960,283369,732533,605551,490466,542368,30573,26330,1025697,177340,747090,845062,287105,926066,438123,793668,934450,256203,249980,657073,590374,746108,657026,515379,501161,560472,872589,142985,794851,994251,899386,1030043,117125,162329,752789,937494,811259,86988,83117,905880,92602,1030647,324134,63299,320858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]