SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502399 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502399 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81435,172927,587677,599354,417394,872301,76287,931959,729178,335977,958605,701297,537684,452570,606696,121331,167145,699569,315931,40303,81936,47553,803096,459671,374667,701272,429676,703036,594856,243201,173275,857718,862072,831068,493901,12036,554919,226297,746271,218652,610294,986140,877819,355497,1025884,94190,1025366,768874,891448,443846,993931,16230,894532,20907,723042,544887,206192,869428,723644,739934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]