SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983601 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983601 [ RunTime:0.002440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457241,12023,950223,1022876,852278,465095,111649,207364,599944,296802,921447,959359,498920,811929,113818,992963,103139,888726,80049,738035,180936,268293,492552,528876,471494,430549,190035,348850,143194,103231,781487,843887,133799,637046,1048329,874763,634408,82437,155151,1041042,273587,661158,235820,728126,529331,12525,205902,23479,952770,4535,851149,700482,125739,425591,326807,996760,834519,534512,652982,83375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]