SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450022 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450022 [ RunTime:0.004127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16187,320544,459009,261928,470098,540898,771448,309431,404976,697718,56125,226761,367100,421945,490920,1015983,910752,246553,527295,697416,988472,740414,989437,892597,323998,183073,955783,267155,255993,603851,950854,293048,27914,110510,384787,155070,814801,922286,365049,628096,111906,217032,266208,637381,34637,468189,131415,380733,978322,989415,1012588,343112,96448,370898,272563,350518,372491,311675,462558,705974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]