SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178230 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178230 [ RunTime:0.002648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335301,438409,57733,726184,241406,596321,91855,938987,685180,450351,797956,957500,229555,1010720,569144,950359,937469,56776,335027,658449,412994,620635,13396,273710,105580,560722,591202,136020,149018,925491,197438,462518,703544,311304,208858,236862,308911,361111,715026,603534,974517,523408,763079,1012105,546797,107660,222314,625068,298510,32457,806071,177658,711004,366044,547062,436716,802698,180569,604909,624834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]